deliveries.js ➔ getDeliveries - Code Metrics - emilfolino/order_api - Measure and Improve Code Quality continuously with Scrutinizer

deliveries.js ➔ getDeliveries A
last analyzed 2025-08-13 07:43 UTC

↳ Parent: v1/models/deliveries.js

Complexity

Conditions

Size

Total Lines	20
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	4
CRAP Score	4.128

Importance

Changes

Metric	Value
eloc	14
dl	0
loc	20
ccs	4
cts	5
cp	0.8
rs	9.7
c	0
b	0
f	0
cc	4
crap	4.128

const db = require("../db/database.js");

module.exports = (function () {
    function getDeliveries(res, apiKey) {
        const sql = "SELECT deliveryId as id, productId as product_id, amount," +
                        " deliveryDate as delivery_date, comment" +
                        " FROM deliveries WHERE apiKey = ?";

        db.all(sql, apiKey, (err, rows) => {
            if (err) {
                return res.status(500).json({
                    errors: {
                        status: 500,
                        source: "/deliveries",
                        title: "Database error",
                        detail: err.message
                    }
                });
            } else {

                res.json({ data: rows });

            }
        });
    }

    function addDelivery(res, body) {
        const sql = "INSERT INTO deliveries (deliveryId, productId, amount, deliveryDate," +
                        " comment, apiKey) VALUES (?, ?, ?, ?, ?, ?)";

        db.run(sql,
            body.id,
            body.product_id,
            body.amount,
            body.delivery_date,
            body.comment,
            body.api_key, (err) => {
                if (err) {
                    return res.status(500).json({
                        errors: {
                            status: 500,
                            source: "/delivery",
                            title: "Database error",
                            detail: err.message
                        }
                    });
                } else {

                    res.status(201).json({ data: body });

                }
            });
    }

    return {
        getDeliveries: getDeliveries,
        addDelivery: addDelivery,
    };
}());


1	1	const db = require("../db/database.js");
2
3	1	module.exports = (function () {
4		function getDeliveries(res, apiKey) {
5	2	const sql = "SELECT deliveryId as id, productId as product_id, amount," +
6		" deliveryDate as delivery_date, comment" +
7		" FROM deliveries WHERE apiKey = ?";
8
9	2	db.all(sql, apiKey, (err, rows) => {
10	2	if (err) {
11		return res.status(500).json({
12		errors: {
13		status: 500,
14		source: "/deliveries",
15		title: "Database error",
16		detail: err.message
17		}
18		});
19		} else {
		0 ignored issues – show Comprehensibility introduced 2019-02-22 14:50 UTC by Report Bug Copy Issue Report `else` is not necessary here since all `if` branches return, consider removing it to reduce nesting and make code more readable. Loading history...
20	2	res.json({ data: rows });
		0 ignored issues – show Best Practice introduced 2019-02-22 14:50 UTC by Report Bug Copy Issue Report There is no `return` statement in this branch, but you do return something in other branches. Did you maybe miss it? If you do not want to return anything, consider adding `return undefined;` explicitly. Loading history...
21		}
22		});
23		}
24
25		function addDelivery(res, body) {
26	6	const sql = "INSERT INTO deliveries (deliveryId, productId, amount, deliveryDate," +
27		" comment, apiKey) VALUES (?, ?, ?, ?, ?, ?)";
28
29	6	db.run(sql,
30		body.id,
31		body.product_id,
32		body.amount,
33		body.delivery_date,
34		body.comment,
35		body.api_key, (err) => {
36	6	if (err) {
37	5	return res.status(500).json({
38		errors: {
39		status: 500,
40		source: "/delivery",
41		title: "Database error",
42		detail: err.message
43		}
44		});
45		} else {
		0 ignored issues – show Comprehensibility introduced 2019-02-22 14:50 UTC by Report Bug Copy Issue Report `else` is not necessary here since all `if` branches return, consider removing it to reduce nesting and make code more readable. Loading history...
46	1	res.status(201).json({ data: body });
		0 ignored issues – show Best Practice introduced 2019-02-22 14:50 UTC by Report Bug Copy Issue Report There is no `return` statement in this branch, but you do return something in other branches. Did you maybe miss it? If you do not want to return anything, consider adding `return undefined;` explicitly. Loading history...
47		}
48		});
49		}
50
51	1	return {
52		getDeliveries: getDeliveries,
53		addDelivery: addDelivery,
54		};
55		}());
56

emilfolino / order_api

deliveries.js ➔ getDeliveries A last analyzed 2025-08-13 07:43 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

deliveries.js ➔ getDeliveries A
last analyzed 2025-08-13 07:43 UTC